Ancillary File Field Mapper Page of the Integration Wizard

Use this page to define the order of the fields in the selected ancillary file.

The file field mapper displays the first 10 rows of data from the file you selected.

Note: If you are importing data that contains quotes in the descriptions, you must use the XLS format of the file. You must also select the File contains a header row option on the Field Mapper page.

Defining the Field Order

Define the data element in each column by selecting values from the drop-down list on the first row of each column. If you want the imported file to contain a header row, select the File contains a header row check box. If the header in the file matches the field in Cobra, the column maps automatically when you select this option.

Additional fields can be mapped using the drop-down list. Select one of the following options:

  • <Ignore>
  • Control account field 1 prompt
  • Control account field 2 prompt — This option is included only if this field is used in the imported file.
  • Control account field 3 prompt — This option is included only if this field is used in the imported file.
  • Work Package prompt

You can select a work package code without control account work package keys.

  • Resource prompt
  • Class
  • Result — This is the actual word Result.

When you select Result, you must also select Result value and vice versa.

  • Result value
  • <Individual Results> — This option separately lists each result defined for the selected project based on the resource file information.

You can select either Result or multiple <Individual Results>. You cannot select both Result and <Individual Results>.

  • Cost_date
  • Project — This option is included only if the selected project is a master project.
  • Code<prompt> — This option lists code prompts on the control account or work package depending on the level of actual costs defined.

With the exception of <Ignore>, you can select an option only once. A selected option is no longer available in subsequent columns.

Note: The data elements displayed in each column depend on the type of ancillary data you are importing. For example, if you are importing a Calendar file, the columns display Calendar fields.